IF NOT EXISTS(SELECT * FROM sys.sysobjects WHERE name ='STIGoodsMapping' and xtype='U')
Begin
CREATE TABLE [dbo].[STIGoodsMapping](
	[GoodsCode] [VARCHAR](15) NOT NULL,
	[TaxCode] [VARCHAR](MAX) NULL,
	[TaxName] [NVARCHAR](MAX) NULL,
	[CreatedBy] [SMALLINT] NULL,
	[CreatedOn] [DATETIME] NULL,
 CONSTRAINT [PK_STIGoodsMapping] PRIMARY KEY CLUSTERED 
(
	[GoodsCode] ASC
) ON [PRIMARY]
) ON [PRIMARY] 


ALTER TABLE [dbo].[STIGoodsMapping] ADD  CONSTRAINT [DF_STIGoodsMapping_CreatedOn]  DEFAULT (GETDATE()) FOR [CreatedOn]	


END

